<%@ page language="java" import="java.util.*,java.sql.*"
	pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<%@page import="com.bean.LoginBean"%>
<%
	LoginBean LoginBean = (LoginBean) session.getAttribute("Loginbean");
	String username = LoginBean.getUsername();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>联系人管理</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>

<body>

	<%
		//定义四个分页会用到的变量
		int pageSize = 10;
		int pageNow = 1;//默认显示第一页
		int rowCount = 0;//该值从数据库中查询
		int pageCount = 0;//该值是通过pageSize和rowCount
		//接受用户希望显示的页数（pageNow）
		String s_pageNow = request.getParameter("pageNow");
		if (s_pageNow != null) {
			//接收到了pageNow
			pageNow = Integer.parseInt(s_pageNow);
		}
		//查询得到rowCount
		Class.forName("com.mysql.jdbc.Driver").newInstance();
		String url = "jdbc:mysql://localhost:3306/graduatedesign";
		String user = "root";
		String password = "root";
		Connection conn = DriverManager.getConnection(url, user, password);
		Statement sm = conn.createStatement();
		ResultSet rs = sm.executeQuery("select count(*) from link where username ='"+username + "'");
		if (rs.next()) {
			rowCount = rs.getInt(1);
		}
		//计算pageCount
		if (rowCount % pageSize == 0) {
			pageCount = rowCount / pageSize;
		} else {
			pageCount = rowCount / pageSize + 1;
		}
		//查询出需要显示的记录
		rs = sm.executeQuery("select linkname from link where username='"
				+ username + "' LIMIT " + (pageNow - 1) * pageSize + ","
				+ pageSize);
	%>

	<table width="100%" border="0" cellpadding="0" cellspacing="1"
		bgcolor="#BBD3EB">
		<tr>
			<td height="27" align="center"
				background="/OA/admin/images/index1_72.gif" bgcolor="#FFFFFF">联系人</td>
			<td heigt="27" align="center"
				background="/OA/admin/images/index1_72.gif" bgcolor="#FFFFFF">删除</td>
		</tr>
		<%
			while (rs.next()) {
		%>
		<tr>
			<td height="26" align="center" bgcolor="#FFFFFF"><a href="admin/linkdetail.jsp?username=<%=rs.getInt(1) %>"><%=rs.getInt(1)%></td>
			<td height="26" align="center" bgcolor="#FFFFFF"><a href="linkdid?linkname=<%=rs.getInt(1)%>" onclick="alert('删除成功')">删除</a>
			</td>
		</tr>
		<%
			}
		%>

	</table>
	<table width="100%" border="0" cellpadding="0" cellspacing="1"
		bgcolor="#BBD3EB">

		<%
			//上一页
			if (pageNow != 1) {
				out.println("<a href=admin/linkmanage.jsp?pageNow="
						+ (pageNow - 1) + ">上一页</a>");
			}
			//显示超链接
			for (int i = 1; i <= pageCount; i++) {
				out.println("<a href=admin/linkmanage.jsp?pageNow=" + i + ">["
						+ i + "]</a>");
			}
			//下一页
			if (pageNow != pageCount) {
				out.println("<a href=admin/linkmanage.jsp?pageNow="
						+ (pageNow + 1) + ">下一页</a>");
			}
		%>
	
</body>
</html>
